# file:  ins_cc1 - sqldba version
# Korn shell script
#
# This script is run once daily to insert records into the CC1 database
# recording the space usage of the databases listed in inserts.sql
# file called by this file.  New databases need to have new
# links created in CC1 and have to have entries in the inserts.sql 
# script.
#
ORACLE_HOME=/orasw/v7;export ORACLE_HOME
ORACLE_SID=cc1; export ORACLE_SID
PATH=$PATH:$ORACLE_HOME/bin; export PATH
cd /orasw/dba/CC1
sqldba lmode=y <<EOF
connect internal
startup;
!sqlplus / @inserts
shutdown
EOF

